Long only 1/n portfolio

import pandas as pd
pd.options.plotting.backend = "plotly"

import yfinance as yf

from cvx.simulator.builder import builder
from cvx.simulator.grid import resample_index

data = yf.download(tickers = "SPY AAPL GOOG MSFT",  # list of tickers
                   period = "10y",                   # time period
                   interval = "1d",                 # trading interval
                   prepost = False,                 # download pre/post market hours data?
                   repair = True)                   # repair obvious price errors e.g. 100x?

[                       0%%                      ]

[**********************50%%                      ]  2 of 4 completed

[**********************75%%**********            ]  3 of 4 completed

[*********************100%%**********************]  4 of 4 completed

prices = data["Adj Close"]

capital = 1e6

b = builder(prices=prices, initial_cash=capital)

for time, state in b:
    # each day we invest a quarter of the capital in the assets
    b[time[-1]] = 0.25 * state.nav / state.prices

portfolio = b.build()
portfolio.profit.cumsum().plot()

portfolio.nav.plot()

Rebalancing

Usually we would not execute on a daily basis but rather rebalance every week, month or quarter. There are two approaches to deal with this problem in cvxsimulator.

• Resample the existing daily portfolio (helpful to see effect of your hesitated trading)

• Trade only on days that are within a predefined grid (most flexible if you have a rather irregular grid)

Resample an existing portfolio

portfolio_resampled = portfolio.resample(rule="M")

frame = pd.DataFrame({"original": portfolio.nav, "monthly": portfolio_resampled.nav})
frame

	original	monthly
Date
2013-09-03	1.000000e+06	1.000000e+06
2013-09-04	1.005178e+06	1.005178e+06
2013-09-05	1.006301e+06	1.006287e+06
2013-09-06	1.007282e+06	1.007296e+06
2013-09-09	1.020259e+06	1.020243e+06
...	...	...
2023-08-28	7.942986e+06	7.922526e+06
2023-08-29	8.099642e+06	8.079520e+06
2023-08-30	8.170668e+06	8.149905e+06
2023-08-31	8.169940e+06	8.149485e+06
2023-09-01	8.188466e+06	8.166973e+06

2518 rows × 2 columns

print(portfolio_resampled.stocks)

                    AAPL          GOOG         MSFT          SPY
Date                                                            
2013-09-03  16416.179816  11666.336302  9364.424147  1827.054117
2013-09-04  16416.179816  11666.336302  9364.424147  1827.054117
2013-09-05  16416.179816  11666.336302  9364.424147  1827.054117
2013-09-06  16416.179816  11666.336302  9364.424147  1827.054117
2013-09-09  16416.179816  11666.336302  9364.424147  1827.054117
...                  ...           ...          ...          ...
2023-08-28  10543.385395  15616.122162  6136.561266  4511.939828
2023-08-29  10543.385395  15616.122162  6136.561266  4511.939828
2023-08-30  10543.385395  15616.122162  6136.561266  4511.939828
2023-08-31  10543.385395  15616.122162  6136.561266  4511.939828
2023-09-01  10805.005907  14964.301507  6228.675436  4537.149495

[2518 rows x 4 columns]

# almost hard to see that difference between the original and resampled portfolio
frame.plot()

# number of shares traded
portfolio_resampled.trades_stocks.iloc[1:].plot()

Trade only days in predefined grid

b = builder(prices=prices, initial_cash=capital)

# define a grid
grid = resample_index(prices.index, rule="M")

for time, state in b:
    # each day we invest a quarter of the capital in the assets
    if time[-1] in grid:
        b[time[-1]] = 0.25 * state.nav / state.prices
    else:
        # forward fill an existing position
        b[time[-1]] = b[time[-2]]
        
portfolio = b.build()

portfolio.nav.plot()

# Trading only once a month can lead to days where 150k had to be reallocated
portfolio.turnover.iloc[1:].plot()

Why not resampling the prices?

I don’t believe in bringing the prices to a monthly grid. This would render it hard to construct signals given the sparse grid. We stay on a daily grid and trade once a month.